﻿begin transaction SchemaUpdate
print 'transaction "SchemaUpdate" started'

begin try
	alter table Word
	drop constraint FK_Word_Language 
	print 'Constraint FK_Word_Language dropped from table "word"'
	
	drop table Language

	commit transaction SchemaUpdate
	print 'transaction "SchemaUpdate" committed'		
end try
begin catch	
	rollback transaction SchemaUpdate
	print 'transaction "SchemaUpdate" rolled back'		
end catch
			
begin transaction DataUpdate
begin try

	update [Version]
	set VersionNr = '1.3'
	print 'VersionNr updated to 1.3'
	
	commit transaction DataUpdate
	print 'transaction "DataUpdate" committed'
end try
begin catch
	rollback transaction DataUpdate
	print 'transaction "DataUpdate" rolled back'
end catch